In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down

Sign up, and CougarBoard will remember which categories you want to view. Sign up

Report problem with this ad

Oct 18, 2024
6:45:30am

Clark Addison All-American

In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down

Report problem with this ad

Clark Addison

Previous username: No One Important
Bio page: Clark Addison
Joined: Apr 14, 2007
Last login: Oct 18, 2024
Total posts: 9,537 (608 FO)

Report problem with this ad

Messages

Author

Time

Before I Google it, I thought I'd ask CougarBoard excel Gurus. Is there a way to add an * before the content

JayOwen Ah dinnae ken

6:43am

In the cell next to the first row: ="*"&A1 (A1 being the cell reference that has the text) then copy down

6:45am

This is the way

gww687

6:46am

That didn't work for me, without doing =CONCAT like silent_T mentioned below

JayOwen

7:01am

CONCAT(“*”, A1)

silent_t

6:47am

Or create a custom format and add it as part of the formatting

trueblueinarizona

6:54am

Thank you Guys, it work.

JayOwen

7:02am

Now to see if the upload works.

JayOwen

7:05am

Didn't work the way I wanted. The import included both answers, including the hidden column.

JayOwen

7:42am

I usually add a ' before to stop the formula from trying to run

7:27am

ChatGPT is the best Excel helper ever. Type in your question and it will give

PabloSanchezz

8:13am

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad