how do i keep a value and get rid of a formula?

S

SPC Ramirez

I'm trying to get three cells to join without the formula.
example:
B1 - Smith
C1 - John
D1 - Mr

A1 - Mr Smith John

how can I make A1 equal that value without using a formula or with using a
formula and then just keeping the value and getting rid of the formula.

Any help or advice will be greatly appreciated
Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Formula 3
Countifs with different restrictions 1
Unique Value Count in 3 Columns Using Search Criteria 0
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
formula that strips the first letter of the first name in a cell 5
Show value from one cell in another cell if today falls between a date range 5
Searching the formula (not the value) for a text string 1

Top